<%--
    Document   : temp
    Created on : Oct 4, 2012, 4:10:02 PM
    Author     : MinhThang
--%>

<%@page import="org.apt.connectDB.MyConnect"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.fckeditor.net" prefix="FCK" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Update news</title>
        <link href="style/css/transdmin.css" rel="stylesheet" type="text/css" media="screen" />
        <link href="../style/style.css" rel="stylesheet" type="text/css" media="screen" />
        <!--[if IE 6]><link rel="stylesheet" type="text/css" media="screen" href="style/css/ie6.css" /><![endif]-->
        <!--[if IE 7]><link rel="stylesheet" type="text/css" media="screen" href="style/css/ie7.css" /><![endif]-->

        <!-- JavaScripts-->
        <script type="text/javascript" src="style/js/jquery.js"></script>
        <script type="text/javascript" src="style/js/jNice.js"></script>
    </head>
    <body>

        <div id="wrapper">
            <h1><a href="#"><span>Admin Paper Presentation</span></a></h1>
            <div><%@include file="Template/header.jsp" %></div>
            <div id="containerHolder">
                <div id="sidebar">
                    <ul class="sideNav">
                        <li class="limenu"><a href="addnews.jsp">Addnews</a></li>
                    </ul>
                    <!-- // .sideNav -->
                </div>
                <h2><a href="#">News >></a> <a href="#" class="active">List News</a></h2>
                <div id="main">
                    <form action="updatenews.do" method="post">
                        <%
                                    Connection conn = null;
                                    PreparedStatement ps = null;
                                    ResultSet rs = null;
                                    String sql = "select * from News where NewsID=?";
                                    request.setAttribute("NewsID", request.getParameter("ID").toString());
                                    try {
                                        conn = MyConnect.getConnection();
                                        ps = conn.prepareCall(sql);
                                        ps.setInt(1, Integer.parseInt(request.getParameter("ID").toString()));
                                        rs = ps.executeQuery();
                                        while (rs.next()) {
                        %>

                        <table border="1" width="100">

                            <tr>
                                <td>Title : <input id="textinput" type="hidden" name="para" value="<%=request.getAttribute("NewsID").toString()%>"/></td>
                                <td><input type="text" id="textinput" name="txtTitle" value="<%=rs.getString("Title").toString()%>" size="40" /></td>

                            </tr>
                            <tr>
                                <td>Summary :</td>
                                <td><input id="textinput" type="text" name="txtSummary" value="<%=rs.getString("Summary").toString()%>" size="40" /></td>

                            </tr>
                            <tr>
                                <td>Author :</td>
                                <td><input id="textinput" type="text" name="txtAuthor" value="<%=rs.getString("Author").toString()%>" size="40" /></td>
                            </tr>
                            <tr>
                                <td>Display News</td>
                                <td>
                                    <select name="ddlDisplayNews">
                                        <option>Enable</option>
                                        <option>Unable</option>
                                    </select>
                                </td>
                            </tr>
                            <tr>
                                <td>Description :</td>
                                <td><input id="textinput"   type="text" name="txtDescription" value="" size="40" /></td>

                            </tr>
                            <tr>
                                <FCK:editor instanceName="editorDefault" height="400">
                                    <jsp:attribute name="value">
                                        <%=rs.getString("Content").toString()%>
                                    </jsp:attribute>
                                </FCK:editor>
                            </tr>
                            <tr>
                                <td align="right">

                                </td>
                                <td>
                                    <input id="pagestatus" type="submit" value="Upload" name="btnUpload" />
                                    <input id="pagestatus" type="reset" value="Clear" name="btnClear" />
                                </td>
                            </tr>
                        </table>

                        <%
                                        }
                                    } catch (Exception e) {
                                        e.printStackTrace();
                                    }
                        %>
                    </form>
                </div>
                <!-- // #main -->
                <div class="clear"></div>
            </div>
        </div>
    </body>
</html>
